A check a constraint that enforces domain integrity by limiting the possible values that can be entered into a column or columns.
Checks are managed on the Checks tab of the Table Designer. Just simply click on a check field for editing. By using the toolbar below, you can create new, edit and delete the selected check field.
Add Check
To add a check
- Open the table in the Table Designer.
- Open the Checks tab.
- Click the
Add Check from the toolbar.
- Edit check properties.
Edit Check
To edit a check
- Open the table in the Table Designer.
- Open the Checks tab.
- Just simply click on the check to edit.
Delete Check
To delete a check
- Open the table in the Table Designer.
- Open the Checks tab.
- Click the
Delete Check from the toolbar.
- Confirm deleting in the dialog window.
See also:
Setting Check Properties